CREATE LOGIN User1 WITH PASSWORD = '12345';
go
use [MMSdata]
go
CREATE USER User1 FOR LOGIN User1 WITH DEFAULT_SCHEMA = MMSdata;                          
EXEC sp_addrolemember db_datareader, User1;
EXEC sp_addrolemember db_datawriter, User1; 
EXEC sp_addrolemember db_owner, User1;
go   